46. Video: OR

Similar to the AND operator, the OR operator can combine multiple statements. Each time you link a new statement with an OR , you will need to specify the column you are interested in looking at. You may link as many statements as you would like to consider at the same time. This operator works with all of the operations we have seen so far including arithmetic operators ( + , * , - , / ), LIKE , IN , NOT , AND , and BETWEEN logic can all be linked together using the OR operator.

When combining multiple of these operations, we frequently might need to use parentheses to assure that logic we want to perform is being executed correctly. The video below shows an example of one of these situations.